<?php
class Test extends CI_Controller{
    public function index(){
        $query = $this->doctrine->em->createQuery("SELECT m from medicament m WHERE m.mednomcommercial= :medic");
		$query->setParameter('medic', 'TRIMYCINE');
		$medic = $query->getSingleResult();
		echo $medic->getMednomcommercial();
		}
}
?>